package com.fowo.api.model.inventory.real;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** 即时库存表 导入导出辅助模型 */
@Getter
@Setter
public class InventoryRealExcelPo {

  @Size(max = 50, message = "仓库内码长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "仓库内码")
  private String stockIdName;

  @ExcelIgnore
  @ExcelProperty(value = "仓库内码")
  private Long stockId;

  @Size(max = 50, message = "sku长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "sku")
  private String sku;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品名")
  private String productName;

  @Size(max = 50, message = "店铺名称长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "店铺名称")
  private String shopName;

  @Size(max = 50, message = "FNSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "FNSKU")
  private String fnSku;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "物料内码")
  private String itemIdName;

  @ExcelIgnore
  @ExcelProperty(value = "物料内码")
  private Long itemId;

  @ExcelProperty(value = "库存数量")
  private Long stockQty;

  @ExcelProperty(value = "库存金额")
  private java.math.BigDecimal stockAmount;

  @ExcelProperty(value = "残次数量")
  private java.math.BigDecimal defectQty;

  @ExcelProperty(value = "在途数量")
  private java.math.BigDecimal wayQty;

  @ExcelProperty(value = "数据版本")
  private Integer version;

  @ExcelProperty(value = "可用量")
  private Integer availbleNum;

  @ExcelProperty(value = "次品量")
  private Integer defectiveQuantity;

  @ExcelProperty(value = "待到货量")
  private Integer wait;

  @ExcelProperty(value = "期望可用量")
  private Integer expectAmount;

  @ExcelProperty(value = "期望待到货量")
  private Integer expectArrive;

  @ExcelProperty(value = "调拨在途")
  private Integer transfer;

  @ExcelProperty(value = "移除在途")
  private Integer removeProgress;

  @ExcelProperty(value = "实际总量")
  private Integer actualTotal;

  @ExcelProperty(value = "预计总量")
  private Integer estimatedTotal;

  @ExcelProperty(value = "采购单价")
  private java.math.BigDecimal purchasePrice;

  @ExcelProperty(value = "单位费用")
  private java.math.BigDecimal unitCosts;

  @ExcelProperty(value = "单位头程")
  private java.math.BigDecimal unitHeadStroke;

  @ExcelProperty(value = "单位库存成本")
  private java.math.BigDecimal unitInventoryCost;

  @ExcelProperty(value = "平均库龄")
  private Integer averageInventoryAge;

  @Size(max = 50, message = "预警状态长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "预警状态")
  private String alertStatus;

  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> img;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "仓位")
  private String posStorageBin;

  @ExcelIgnore
  @ExcelProperty(value = "仓位")
  private Long pos;
}
